How to: Prevent duplicate records from displaying in query results.
Solution:
Click in query design view, select the 'View' menu and select 'Properties', then select the 'Unique Values' box and select 'Yes' from the drop-down menu.
1) If the Database window is not active, activate the Database window.
2) Click the 'Queries' tab in the Database window.
Queries tab
3) Select the desired query. (The query is highlighted.)
4) Click 'Design'. (The query appears in Query Design view.)
5) Click in the query design view above the design grid.
6) Select the 'View' menu and select 'Properties'. (The Query Properties window appears.)
7) Click on the 'Unique Values' box. (A down arrow appears.)
8) Click down arrow. (A drop-down list appears.)
9) Select 'Yes' from the 'Unique Values' drop-down list.
10) Select the 'File' menu and select 'Save' to save the query.
11) Select the 'Query' menu and select 'Run' to run the query.
